Churn Analysis Report

Dataset statistics

Number of variables	26
Number of observations	14606
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.9 MiB
Average record size in memory	208.0 B

Variable types

Categorical	8
Numeric	17
Boolean	1

Alerts

`id` has a high cardinality: 14606 distinct values	High cardinality
`date_activ` has a high cardinality: 1796 distinct values	High cardinality
`date_end` has a high cardinality: 368 distinct values	High cardinality
`date_modif_prod` has a high cardinality: 2129 distinct values	High cardinality
`date_renewal` has a high cardinality: 386 distinct values	High cardinality
`cons_12m` is highly correlated with `cons_last_month` and 2 other fields	High correlation
`cons_gas_12m` is highly correlated with `nb_prod_act`	High correlation
`cons_last_month` is highly correlated with `cons_12m` and 2 other fields	High correlation
`forecast_cons_12m` is highly correlated with `cons_12m` and 3 other fields	High correlation
`forecast_cons_year` is highly correlated with `cons_last_month` and 3 other fields	High correlation
`forecast_meter_rent_12m` is highly correlated with `forecast_price_energy_off_peak` and 3 other fields	High correlation
`forecast_price_energy_off_peak` is highly correlated with `forecast_meter_rent_12m` and 2 other fields	High correlation
`forecast_price_energy_peak` is highly correlated with `forecast_meter_rent_12m` and 2 other fields	High correlation
`forecast_price_pow_off_peak` is highly correlated with `forecast_meter_rent_12m` and 3 other fields	High correlation
`imp_cons` is highly correlated with `cons_last_month` and 3 other fields	High correlation
`margin_gross_pow_ele` is highly correlated with `margin_net_pow_ele`	High correlation
`margin_net_pow_ele` is highly correlated with `margin_gross_pow_ele`	High correlation
`nb_prod_act` is highly correlated with `cons_gas_12m`	High correlation
`net_margin` is highly correlated with `cons_12m` and 3 other fields	High correlation
`pow_max` is highly correlated with `forecast_meter_rent_12m` and 3 other fields	High correlation
`cons_12m` is highly correlated with `cons_last_month`	High correlation
`cons_gas_12m` is highly correlated with `cons_last_month`	High correlation
`cons_last_month` is highly correlated with `cons_12m` and 1 other fields	High correlation
`forecast_cons_12m` is highly correlated with `forecast_cons_year` and 2 other fields	High correlation
`forecast_cons_year` is highly correlated with `forecast_cons_12m` and 1 other fields	High correlation
`forecast_meter_rent_12m` is highly correlated with `forecast_price_energy_off_peak` and 2 other fields	High correlation
`forecast_price_energy_off_peak` is highly correlated with `forecast_meter_rent_12m` and 1 other fields	High correlation
`forecast_price_energy_peak` is highly correlated with `forecast_meter_rent_12m`	High correlation
`forecast_price_pow_off_peak` is highly correlated with `forecast_price_energy_off_peak`	High correlation
`imp_cons` is highly correlated with `forecast_cons_12m` and 1 other fields	High correlation
`margin_gross_pow_ele` is highly correlated with `margin_net_pow_ele`	High correlation
`margin_net_pow_ele` is highly correlated with `margin_gross_pow_ele`	High correlation
`net_margin` is highly correlated with `forecast_cons_12m`	High correlation
`pow_max` is highly correlated with `forecast_meter_rent_12m`	High correlation
`cons_12m` is highly correlated with `cons_last_month` and 2 other fields	High correlation
`cons_gas_12m` is highly correlated with `nb_prod_act`	High correlation
`cons_last_month` is highly correlated with `cons_12m` and 2 other fields	High correlation
`forecast_cons_12m` is highly correlated with `cons_12m` and 1 other fields	High correlation
`forecast_cons_year` is highly correlated with `cons_last_month` and 1 other fields	High correlation
`forecast_price_energy_off_peak` is highly correlated with `forecast_price_pow_off_peak`	High correlation
`forecast_price_energy_peak` is highly correlated with `forecast_price_pow_off_peak` and 1 other fields	High correlation
`forecast_price_pow_off_peak` is highly correlated with `forecast_price_energy_off_peak` and 2 other fields	High correlation
`imp_cons` is highly correlated with `cons_last_month` and 1 other fields	High correlation
`margin_gross_pow_ele` is highly correlated with `margin_net_pow_ele`	High correlation
`margin_net_pow_ele` is highly correlated with `margin_gross_pow_ele`	High correlation
`nb_prod_act` is highly correlated with `cons_gas_12m`	High correlation
`net_margin` is highly correlated with `cons_12m` and 1 other fields	High correlation
`pow_max` is highly correlated with `forecast_price_energy_peak` and 1 other fields	High correlation
`cons_12m` is highly correlated with `cons_gas_12m` and 1 other fields	High correlation
`cons_gas_12m` is highly correlated with `cons_12m` and 1 other fields	High correlation
`cons_last_month` is highly correlated with `cons_12m` and 1 other fields	High correlation
`forecast_cons_12m` is highly correlated with `forecast_cons_year` and 4 other fields	High correlation
`forecast_cons_year` is highly correlated with `forecast_cons_12m` and 1 other fields	High correlation
`forecast_discount_energy` is highly correlated with `forecast_cons_12m` and 3 other fields	High correlation
`forecast_meter_rent_12m` is highly correlated with `forecast_price_energy_off_peak` and 3 other fields	High correlation
`forecast_price_energy_off_peak` is highly correlated with `forecast_discount_energy` and 6 other fields	High correlation
`forecast_price_energy_peak` is highly correlated with `forecast_discount_energy` and 3 other fields	High correlation
`forecast_price_pow_off_peak` is highly correlated with `forecast_meter_rent_12m` and 3 other fields	High correlation
`imp_cons` is highly correlated with `forecast_cons_12m` and 2 other fields	High correlation
`margin_gross_pow_ele` is highly correlated with `forecast_price_energy_off_peak` and 1 other fields	High correlation
`margin_net_pow_ele` is highly correlated with `forecast_price_energy_off_peak` and 1 other fields	High correlation
`net_margin` is highly correlated with `forecast_cons_12m` and 2 other fields	High correlation
`num_years_antig` is highly correlated with `forecast_price_energy_off_peak` and 2 other fields	High correlation
`origin_up` is highly correlated with `num_years_antig`	High correlation
`pow_max` is highly correlated with `forecast_cons_12m` and 1 other fields	High correlation
`net_margin` is highly skewed (γ1 = 36.56951466)	Skewed
`id` is uniformly distributed	Uniform
`id` has unique values	Unique
`cons_gas_12m` has 11994 (82.1%) zeros	Zeros
`cons_last_month` has 4983 (34.1%) zeros	Zeros
`forecast_cons_12m` has 306 (2.1%) zeros	Zeros
`forecast_cons_year` has 6148 (42.1%) zeros	Zeros
`forecast_discount_energy` has 14094 (96.5%) zeros	Zeros
`forecast_meter_rent_12m` has 725 (5.0%) zeros	Zeros
`forecast_price_energy_peak` has 7021 (48.1%) zeros	Zeros
`imp_cons` has 6169 (42.2%) zeros	Zeros
`margin_gross_pow_ele` has 157 (1.1%) zeros	Zeros
`margin_net_pow_ele` has 157 (1.1%) zeros	Zeros
`net_margin` has 185 (1.3%) zeros	Zeros

Reproduction

Analysis started	2022-04-05 18:18:58.078452
Analysis finished	2022-04-05 18:22:32.811110
Duration	3 minutes and 34.73 seconds
Software version	pandas-profiling v3.1.1
Download configuration	config.json

id
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	14606
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	114.2 KiB

303740e6ba50bbb6aca61dbe1b0994f5	1
abcfc174050f9dabbccfb52de2db7417	1
508f77b2738091ae41b7bcda284416b3	1
7bbe17ea1417fd9e84287b291194c925	1
ca3b1f3d0959fd8fc6bb8d690ce2409e	1
Other values (14601)	14601

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	467392
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14606 ?
Unique (%)	100.0%

Sample

1st row	24011ae4ebbe3035111d65fa7c15bc57
2nd row	d29c2c54acc38ff3c0614d0a653813dd
3rd row	764c75f661154dac3a6c254cd082ea7d
4th row	bba03439a292a1e166f80264c16191cb
5th row	149d57cf92fc41cf94415803a877cb4b

Common Values

Value	Count	Frequency (%)
303740e6ba50bbb6aca61dbe1b0994f5	1	< 0.1%
abcfc174050f9dabbccfb52de2db7417	1	< 0.1%
508f77b2738091ae41b7bcda284416b3	1	< 0.1%
7bbe17ea1417fd9e84287b291194c925	1	< 0.1%
ca3b1f3d0959fd8fc6bb8d690ce2409e	1	< 0.1%
d44b5c7227d9cd0188a6d5871e1cbf3f	1	< 0.1%
cf99781308d7f93fa1d7fde6e49467ee	1	< 0.1%
e46bb9a2dc590624ecd7c29e2b2d2c1c	1	< 0.1%
47d4e820f1ef653c4007eb43ce32ecd0	1	< 0.1%
9dce82a4ac2d7af52e593d484e935ba7	1	< 0.1%
Other values (14596)	14596	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
91a15ff32a1886a3e2d481b281039779	1	< 0.1%
3837fee9f948dca6612c45bef8b2583d	1	< 0.1%
a8e9d5d93381eb69d8149595a7d73a18	1	< 0.1%
bad4892ef67fbdfbb53c4139900a266e	1	< 0.1%
9296a3ca343aca9bf4bc6a971a8c7f76	1	< 0.1%
f46e1995fdd251b8b4118e10c7d2bbf6	1	< 0.1%
c86963c89f24623d72567b06d9c2debe	1	< 0.1%
1f9547c3c7a8aabda46907526972147c	1	< 0.1%
29f9c53daea90ad1365ba36ab1f6b222	1	< 0.1%
5747d5d77fcbf6a77eae04adc6d99892	1	< 0.1%
Other values (14596)	14596	99.9%

Most occurring characters

Value	Count	Frequency (%)
6	29453	6.3%
e	29432	6.3%
7	29400	6.3%
4	29381	6.3%
2	29375	6.3%
b	29313	6.3%
3	29297	6.3%
1	29257	6.3%
c	29210	6.2%
a	29169	6.2%
Other values (6)	174105	37.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	292239	62.5%
Lowercase Letter	175153	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	29453	10.1%
7	29400	10.1%
4	29381	10.1%
2	29375	10.1%
3	29297	10.0%
1	29257	10.0%
8	29153	10.0%
0	29090	10.0%
9	29012	9.9%
5	28821	9.9%

Lowercase Letter

Value	Count	Frequency (%)
e	29432	16.8%
b	29313	16.7%
c	29210	16.7%
a	29169	16.7%
d	29137	16.6%
f	28892	16.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	292239	62.5%
Latin	175153	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
6	29453	10.1%
7	29400	10.1%
4	29381	10.1%
2	29375	10.1%
3	29297	10.0%
1	29257	10.0%
8	29153	10.0%
0	29090	10.0%
9	29012	9.9%
5	28821	9.9%

Latin

Value	Count	Frequency (%)
e	29432	16.8%
b	29313	16.7%
c	29210	16.7%
a	29169	16.7%
d	29137	16.6%
f	28892	16.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	467392	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	29453	6.3%
e	29432	6.3%
7	29400	6.3%
4	29381	6.3%
2	29375	6.3%
b	29313	6.3%
3	29297	6.3%
1	29257	6.3%
c	29210	6.2%
a	29169	6.2%
Other values (6)	174105	37.3%

channel_sales
Categorical

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	114.2 KiB

foosdfpfkusacimwkcsosbicdxkicaua	6754
MISSING	3725
lmkebamcaaclubfxadlmueccxoimlema	1843
usilxuppasemubllopkaafesmlibmsdf	1375
ewpakwlliwisiwduibdlfmalxowmwpci	893
Other values (3)	16

Length

Max length	32
Median length	32
Mean length	25.62419554
Min length	7

Characters and Unicode

Total characters	374267
Distinct characters	21
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	foosdfpfkusacimwkcsosbicdxkicaua
2nd row	MISSING
3rd row	foosdfpfkusacimwkcsosbicdxkicaua
4th row	lmkebamcaaclubfxadlmueccxoimlema
5th row	MISSING

Common Values

Value	Count	Frequency (%)
foosdfpfkusacimwkcsosbicdxkicaua	6754	46.2%
MISSING	3725	25.5%
lmkebamcaaclubfxadlmueccxoimlema	1843	12.6%
usilxuppasemubllopkaafesmlibmsdf	1375	9.4%
ewpakwlliwisiwduibdlfmalxowmwpci	893	6.1%
sddiedcslfslkckwlfkdpoeeailfpeds	11	0.1%
epumfxlbckeskwekxbiuasklxalciiuu	3	< 0.1%
fixdbufsefwooaasfcxdxadsiekoceaa	2	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
foosdfpfkusacimwkcsosbicdxkicaua	6754	46.2%
missing	3725	25.5%
lmkebamcaaclubfxadlmueccxoimlema	1843	12.6%
usilxuppasemubllopkaafesmlibmsdf	1375	9.4%
ewpakwlliwisiwduibdlfmalxowmwpci	893	6.1%
sddiedcslfslkckwlfkdpoeeailfpeds	11	0.1%
epumfxlbckeskwekxbiuasklxalciiuu	3	< 0.1%
fixdbufsefwooaasfcxdxadsiekoceaa	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	35415	9.5%
c	35313	9.4%
s	33465	8.9%
i	29355	7.8%
f	25792	6.9%
k	24420	6.5%
o	24390	6.5%
u	22226	5.9%
m	21883	5.8%
d	18573	5.0%
Other values (11)	103435	27.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	348192	93.0%
Uppercase Letter	26075	7.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	35415	10.2%
c	35313	10.1%
s	33465	9.6%
i	29355	8.4%
f	25792	7.4%
k	24420	7.0%
o	24390	7.0%
u	22226	6.4%
m	21883	6.3%
d	18573	5.3%
Other values (6)	77360	22.2%

Uppercase Letter

Value	Count	Frequency (%)
I	7450	28.6%
S	7450	28.6%
M	3725	14.3%
N	3725	14.3%
G	3725	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	374267	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	35415	9.5%
c	35313	9.4%
s	33465	8.9%
i	29355	7.8%
f	25792	6.9%
k	24420	6.5%
o	24390	6.5%
u	22226	5.9%
m	21883	5.8%
d	18573	5.0%
Other values (11)	103435	27.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	374267	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	35415	9.5%
c	35313	9.4%
s	33465	8.9%
i	29355	7.8%
f	25792	6.9%
k	24420	6.5%
o	24390	6.5%
u	22226	5.9%
m	21883	5.8%
d	18573	5.0%
Other values (11)	103435	27.6%

cons_12m
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	11065
Distinct (%)	75.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	159220.2863

Minimum	0
Maximum	6207104
Zeros	117
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1512.25
Q1	5674.75
median	14115.5
Q3	40763.75
95-th percentile	913771.75
Maximum	6207104
Range	6207104
Interquartile range (IQR)	35089

Descriptive statistics

Standard deviation	573465.2642
Coefficient of variation (CV)	3.601709793
Kurtosis	42.68977714
Mean	159220.2863
Median Absolute Deviation (MAD)	10669
Skewness	5.997308122
Sum	2325571501
Variance	3.288624092 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	117	0.8%
2882597	27	0.2%
3329244	24	0.2%
6207104	18	0.1%
1743025	18	0.1%
3926060	18	0.1%
1722179	17	0.1%
2288838	17	0.1%
2503923	16	0.1%
963288	16	0.1%
Other values (11055)	14318	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	117	0.8%
1	2	< 0.1%
2	2	< 0.1%
3	4	< 0.1%
4	2	< 0.1%
5	1	< 0.1%
6	2	< 0.1%
7	3	< 0.1%
9	2	< 0.1%
10	4	< 0.1%

Value	Count	Frequency (%)
6207104	18	0.1%
5731448	14	0.1%
5322441	1	< 0.1%
5161456	4	< 0.1%
4939487	4	< 0.1%
4406520	14	0.1%
4306656	9	0.1%
4199490	5	< 0.1%
4100379	13	0.1%
4012564	2	< 0.1%

cons_gas_12m
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	2112
Distinct (%)	14.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28092.37533

Minimum	0
Maximum	4154590
Zeros	11994
Zeros (%)	82.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	75854
Maximum	4154590
Range	4154590
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	162973.0591
Coefficient of variation (CV)	5.801327128
Kurtosis	126.3336345
Mean	28092.37533
Median Absolute Deviation (MAD)	0
Skewness	9.59752999
Sum	410317234
Variance	2.656021798 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11994	82.1%
976731	27	0.2%
867921	24	0.2%
41532	18	0.1%
1959386	18	0.1%
1192414	17	0.1%
475413	16	0.1%
468369	15	0.1%
1337056	14	0.1%
187578	13	0.1%
Other values (2102)	2450	16.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11994	82.1%
11	7	< 0.1%
12	2	< 0.1%
21	2	< 0.1%
32	1	< 0.1%
35	2	< 0.1%
36	1	< 0.1%
41	1	< 0.1%
43	2	< 0.1%
46	1	< 0.1%

Value	Count	Frequency (%)
4154590	2	< 0.1%
2813019	2	< 0.1%
2055098	2	< 0.1%
1959386	18	0.1%
1860052	4	< 0.1%
1859491	3	< 0.1%
1813943	1	< 0.1%
1711930	1	< 0.1%
1653924	2	< 0.1%
1542867	1	< 0.1%

cons_last_month
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	4751
Distinct (%)	32.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16090.26975

Minimum	0
Maximum	771203
Zeros	4983
Zeros (%)	34.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	792.5
Q3	3383
95-th percentile	82161.5
Maximum	771203
Range	771203
Interquartile range (IQR)	3383

Descriptive statistics

Standard deviation	64364.19642
Coefficient of variation (CV)	4.000193745
Kurtosis	47.76299141
Mean	16090.26975
Median Absolute Deviation (MAD)	792.5
Skewness	6.391406975
Sum	235014480
Variance	4142749781
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4983	34.1%
382647	27	0.2%
509826	24	0.2%
558120	18	0.1%
469210	18	0.1%
106161	18	0.1%
181187	17	0.1%
237044	17	0.1%
54281	16	0.1%
313018	16	0.1%
Other values (4741)	9452	64.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4983	34.1%
1	13	0.1%
2	5	< 0.1%
3	5	< 0.1%
4	4	< 0.1%
5	5	< 0.1%
6	2	< 0.1%
7	5	< 0.1%
8	5	< 0.1%
9	4	< 0.1%

Value	Count	Frequency (%)
771203	14	0.1%
760727	1	< 0.1%
612247	1	< 0.1%
558120	18	0.1%
509826	24	0.2%
507598	14	0.1%
479030	9	0.1%
469898	2	< 0.1%
469210	18	0.1%
456462	5	< 0.1%

date_activ
Categorical

HIGH CARDINALITY

Distinct	1796
Distinct (%)	12.3%
Missing	0
Missing (%)	0.0%
Memory size	114.2 KiB

2009-08-01	95
2010-02-01	92
2009-09-01	76
2009-10-01	55
2012-02-01	48
Other values (1791)	14240

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	146060
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	452 ?
Unique (%)	3.1%

Sample

1st row	2013-06-15
2nd row	2009-08-21
3rd row	2010-04-16
4th row	2010-03-30
5th row	2010-01-13

Common Values

Value	Count	Frequency (%)
2009-08-01	95	0.7%
2010-02-01	92	0.6%
2009-09-01	76	0.5%
2009-10-01	55	0.4%
2012-02-01	48	0.3%
2010-01-11	48	0.3%
2010-01-18	47	0.3%
2011-12-15	45	0.3%
2010-06-10	42	0.3%
2011-11-23	41	0.3%
Other values (1786)	14017	96.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2009-08-01	95	0.7%
2010-02-01	92	0.6%
2009-09-01	76	0.5%
2009-10-01	55	0.4%
2012-02-01	48	0.3%
2010-01-11	48	0.3%
2010-01-18	47	0.3%
2011-12-15	45	0.3%
2010-06-10	42	0.3%
2011-11-23	41	0.3%
Other values (1786)	14017	96.0%

Most occurring characters

Value	Count	Frequency (%)
0	40175	27.5%
-	29212	20.0%
1	27567	18.9%
2	26396	18.1%
9	5098	3.5%
3	4311	3.0%
6	2750	1.9%
8	2725	1.9%
5	2632	1.8%
4	2625	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	116848	80.0%
Dash Punctuation	29212	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	40175	34.4%
1	27567	23.6%
2	26396	22.6%
9	5098	4.4%
3	4311	3.7%
6	2750	2.4%
8	2725	2.3%
5	2632	2.3%
4	2625	2.2%
7	2569	2.2%

Dash Punctuation

Value	Count	Frequency (%)
-	29212	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	146060	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	40175	27.5%
-	29212	20.0%
1	27567	18.9%
2	26396	18.1%
9	5098	3.5%
3	4311	3.0%
6	2750	1.9%
8	2725	1.9%
5	2632	1.8%
4	2625	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	146060	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	40175	27.5%
-	29212	20.0%
1	27567	18.9%
2	26396	18.1%
9	5098	3.5%
3	4311	3.0%
6	2750	1.9%
8	2725	1.9%
5	2632	1.8%
4	2625	1.8%

date_end
Categorical

HIGH CARDINALITY

Distinct	368
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Memory size	114.2 KiB

2016-02-01	145
2016-08-01	125
2016-09-01	117
2016-10-05	115
2016-12-31	104
Other values (363)	14000

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	146060
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	2016-06-15
2nd row	2016-08-30
3rd row	2016-04-16
4th row	2016-03-30
5th row	2016-03-07

Common Values

Value	Count	Frequency (%)
2016-02-01	145	1.0%
2016-08-01	125	0.9%
2016-09-01	117	0.8%
2016-10-05	115	0.8%
2016-12-31	104	0.7%
2016-10-25	103	0.7%
2016-09-02	93	0.6%
2016-06-10	80	0.5%
2016-06-01	79	0.5%
2016-03-01	78	0.5%
Other values (358)	13567	92.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2016-02-01	145	1.0%
2016-08-01	125	0.9%
2016-09-01	117	0.8%
2016-10-05	115	0.8%
2016-12-31	104	0.7%
2016-10-25	103	0.7%
2016-09-02	93	0.6%
2016-06-10	80	0.5%
2016-06-01	79	0.5%
2016-11-12	78	0.5%
Other values (358)	13567	92.9%

Most occurring characters

Value	Count	Frequency (%)
0	33124	22.7%
-	29212	20.0%
1	27832	19.1%
2	22902	15.7%
6	16275	11.1%
7	3421	2.3%
3	3291	2.3%
5	2549	1.7%
8	2536	1.7%
9	2494	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	116848	80.0%
Dash Punctuation	29212	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	33124	28.3%
1	27832	23.8%
2	22902	19.6%
6	16275	13.9%
7	3421	2.9%
3	3291	2.8%
5	2549	2.2%
8	2536	2.2%
9	2494	2.1%
4	2424	2.1%

Dash Punctuation

Value	Count	Frequency (%)
-	29212	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	146060	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	33124	22.7%
-	29212	20.0%
1	27832	19.1%
2	22902	15.7%
6	16275	11.1%
7	3421	2.3%
3	3291	2.3%
5	2549	1.7%
8	2536	1.7%
9	2494	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	146060	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	33124	22.7%
-	29212	20.0%
1	27832	19.1%
2	22902	15.7%
6	16275	11.1%
7	3421	2.3%
3	3291	2.3%
5	2549	1.7%
8	2536	1.7%
9	2494	1.7%

date_modif_prod
Categorical

HIGH CARDINALITY

Distinct	2129
Distinct (%)	14.6%
Missing	0
Missing (%)	0.0%
Memory size	114.2 KiB

2015-11-01	721
2015-05-24	269
2015-12-17	199
2015-09-20	173
2015-12-16	172
Other values (2124)	13072

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	146060
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	550 ?
Unique (%)	3.8%

Sample

1st row	2015-11-01
2nd row	2009-08-21
3rd row	2010-04-16
4th row	2010-03-30
5th row	2010-01-13

Common Values

Value	Count	Frequency (%)
2015-11-01	721	4.9%
2015-05-24	269	1.8%
2015-12-17	199	1.4%
2015-09-20	173	1.2%
2015-12-16	172	1.2%
2015-11-18	164	1.1%
2015-07-11	158	1.1%
2015-04-29	155	1.1%
2015-08-27	150	1.0%
2015-10-30	149	1.0%
Other values (2119)	12296	84.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2015-11-01	721	4.9%
2015-05-24	269	1.8%
2015-12-17	199	1.4%
2015-09-20	173	1.2%
2015-12-16	172	1.2%
2015-11-18	164	1.1%
2015-07-11	158	1.1%
2015-04-29	155	1.1%
2015-08-27	150	1.0%
2015-10-30	149	1.0%
Other values (2119)	12296	84.2%

Most occurring characters

Value	Count	Frequency (%)
0	36132	24.7%
-	29212	20.0%
1	29112	19.9%
2	23330	16.0%
5	7646	5.2%
4	4177	2.9%
3	4096	2.8%
9	3851	2.6%
7	3055	2.1%
6	2959	2.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	116848	80.0%
Dash Punctuation	29212	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	36132	30.9%
1	29112	24.9%
2	23330	20.0%
5	7646	6.5%
4	4177	3.6%
3	4096	3.5%
9	3851	3.3%
7	3055	2.6%
6	2959	2.5%
8	2490	2.1%

Dash Punctuation

Value	Count	Frequency (%)
-	29212	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	146060	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	36132	24.7%
-	29212	20.0%
1	29112	19.9%
2	23330	16.0%
5	7646	5.2%
4	4177	2.9%
3	4096	2.8%
9	3851	2.6%
7	3055	2.1%
6	2959	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	146060	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	36132	24.7%
-	29212	20.0%
1	29112	19.9%
2	23330	16.0%
5	7646	5.2%
4	4177	2.9%
3	4096	2.8%
9	3851	2.6%
7	3055	2.1%
6	2959	2.0%

date_renewal
Categorical

HIGH CARDINALITY

Distinct	386
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	114.2 KiB

2015-06-23	587
2015-03-09	451
2015-02-09	273
2015-07-04	265
2015-10-11	231
Other values (381)	12799

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	146060
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	71 ?
Unique (%)	0.5%

Sample

1st row	2015-06-23
2nd row	2015-08-31
3rd row	2015-04-17
4th row	2015-03-31
5th row	2015-03-09

Common Values

Value	Count	Frequency (%)
2015-06-23	587	4.0%
2015-03-09	451	3.1%
2015-02-09	273	1.9%
2015-07-04	265	1.8%
2015-10-11	231	1.6%
2015-06-14	220	1.5%
2015-03-06	203	1.4%
2015-06-08	148	1.0%
2015-05-23	140	1.0%
2015-07-09	137	0.9%
Other values (376)	11951	81.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2015-06-23	587	4.0%
2015-03-09	451	3.1%
2015-02-09	273	1.9%
2015-07-04	265	1.8%
2015-10-11	231	1.6%
2015-06-14	220	1.5%
2015-03-06	203	1.4%
2015-06-08	148	1.0%
2015-05-23	140	1.0%
2015-07-09	137	0.9%
Other values (376)	11951	81.8%

Most occurring characters

Value	Count	Frequency (%)
0	32467	22.2%
-	29212	20.0%
1	27367	18.7%
2	23246	15.9%
5	15212	10.4%
6	3964	2.7%
3	3857	2.6%
9	3178	2.2%
4	3033	2.1%
8	2302	1.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	116848	80.0%
Dash Punctuation	29212	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	32467	27.8%
1	27367	23.4%
2	23246	19.9%
5	15212	13.0%
6	3964	3.4%
3	3857	3.3%
9	3178	2.7%
4	3033	2.6%
8	2302	2.0%
7	2222	1.9%

Dash Punctuation

Value	Count	Frequency (%)
-	29212	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	146060	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	32467	22.2%
-	29212	20.0%
1	27367	18.7%
2	23246	15.9%
5	15212	10.4%
6	3964	2.7%
3	3857	2.6%
9	3178	2.2%
4	3033	2.1%
8	2302	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	146060	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	32467	22.2%
-	29212	20.0%
1	27367	18.7%
2	23246	15.9%
5	15212	10.4%
6	3964	2.7%
3	3857	2.6%
9	3178	2.2%
4	3033	2.1%
8	2302	1.6%

forecast_cons_12m
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	13993
Distinct (%)	95.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1868.61488

Minimum	0
Maximum	82902.83
Zeros	306
Zeros (%)	2.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	84.9175
Q1	494.995
median	1112.875
Q3	2401.79
95-th percentile	6127.095
Maximum	82902.83
Range	82902.83
Interquartile range (IQR)	1906.795

Descriptive statistics

Standard deviation	2387.571531
Coefficient of variation (CV)	1.277722637
Kurtosis	147.4266807
Mean	1868.61488
Median Absolute Deviation (MAD)	752.955
Skewness	7.155852616
Sum	27292988.93
Variance	5700497.814
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	306	2.1%
0.15	6	< 0.1%
415.14	4	< 0.1%
0.3	3	< 0.1%
651.21	3	< 0.1%
1210.67	3	< 0.1%
0.45	3	< 0.1%
335.5	3	< 0.1%
1539.37	3	< 0.1%
442.74	3	< 0.1%
Other values (13983)	14269	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	306	2.1%
0.1	1	< 0.1%
0.15	6	< 0.1%
0.18	1	< 0.1%
0.2	1	< 0.1%
0.3	3	< 0.1%
0.32	1	< 0.1%
0.33	1	< 0.1%
0.42	2	< 0.1%
0.45	3	< 0.1%

Value	Count	Frequency (%)
82902.83	1	< 0.1%
61357.17	1	< 0.1%
48412.58	1	< 0.1%
35789.29	1	< 0.1%
35312.21	1	< 0.1%
32174.47	1	< 0.1%
31347.11	1	< 0.1%
30533.99	1	< 0.1%
28375.76	1	< 0.1%
27618.39	1	< 0.1%

forecast_cons_year
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	4218
Distinct (%)	28.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1399.762906

Minimum	0
Maximum	175375
Zeros	6148
Zeros (%)	42.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	314
Q3	1745.75
95-th percentile	5968.75
Maximum	175375
Range	175375
Interquartile range (IQR)	1745.75

Descriptive statistics

Standard deviation	3247.786255
Coefficient of variation (CV)	2.320240265
Kurtosis	653.7344073
Mean	1399.762906
Median Absolute Deviation (MAD)	314
Skewness	16.58798968
Sum	20444937
Variance	10548115.56
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6148	42.1%
8	13	0.1%
1	13	0.1%
7	11	0.1%
453	11	0.1%
524	9	0.1%
420	9	0.1%
34	9	0.1%
310	9	0.1%
331	9	0.1%
Other values (4208)	8365	57.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6148	42.1%
1	13	0.1%
2	9	0.1%
3	5	< 0.1%
4	8	0.1%
5	7	< 0.1%
6	5	< 0.1%
7	11	0.1%
8	13	0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
175375	1	< 0.1%
79127	1	< 0.1%
70180	1	< 0.1%
66643	1	< 0.1%
63969	1	< 0.1%
59460	1	< 0.1%
51604	1	< 0.1%
51336	1	< 0.1%
50106	1	< 0.1%
46491	1	< 0.1%

forecast_discount_energy
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.966726003

Minimum	0
Maximum	30
Zeros	14094
Zeros (%)	96.5%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	30
Range	30
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.108288697
Coefficient of variation (CV)	5.284112231
Kurtosis	24.85471185
Mean	0.966726003
Median Absolute Deviation (MAD)	0
Skewness	5.155098289
Sum	14120
Variance	26.09461341
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	14094	96.5%
30	260	1.8%
28	102	0.7%
24	83	0.6%
22	47	0.3%
25	7	< 0.1%
26	5	< 0.1%
19	2	< 0.1%
17	2	< 0.1%
23	2	< 0.1%
Other values (2)	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14094	96.5%
5	1	< 0.1%
10	1	< 0.1%
17	2	< 0.1%
19	2	< 0.1%
22	47	0.3%
23	2	< 0.1%
24	83	0.6%
25	7	< 0.1%
26	5	< 0.1%

Value	Count	Frequency (%)
30	260	1.8%
28	102	0.7%
26	5	< 0.1%
25	7	< 0.1%
24	83	0.6%
23	2	< 0.1%
22	47	0.3%
19	2	< 0.1%
17	2	< 0.1%
10	1	< 0.1%

forecast_meter_rent_12m
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	3528
Distinct (%)	24.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63.08687115

Minimum	0
Maximum	599.31
Zeros	725
Zeros (%)	5.0%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.3325
Q1	16.18
median	18.795
Q3	131.03
95-th percentile	145.72
Maximum	599.31
Range	599.31
Interquartile range (IQR)	114.85

Descriptive statistics

Standard deviation	66.16578283
Coefficient of variation (CV)	1.048804317
Kurtosis	4.491521412
Mean	63.08687115
Median Absolute Deviation (MAD)	9.315
Skewness	1.505147852
Sum	921446.84
Variance	4377.910818
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	725	5.0%
131.76	238	1.6%
18.32	162	1.1%
18.37	131	0.9%
129.61	103	0.7%
15.98	100	0.7%
131.38	78	0.5%
18.47	77	0.5%
16.26	76	0.5%
18.42	74	0.5%
Other values (3518)	12842	87.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	725	5.0%
0.09	1	< 0.1%
0.18	1	< 0.1%
0.24	1	< 0.1%
0.27	1	< 0.1%
0.31	1	< 0.1%
0.33	1	< 0.1%
0.34	2	< 0.1%
0.35	2	< 0.1%
0.36	6	< 0.1%

Value	Count	Frequency (%)
599.31	5	< 0.1%
585.62	1	< 0.1%
562.13	1	< 0.1%
552.9	1	< 0.1%
548.41	1	< 0.1%
439.67	1	< 0.1%
434.04	1	< 0.1%
407.98	1	< 0.1%
407.97	9	0.1%
406.45	1	< 0.1%

forecast_price_energy_off_peak
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	516
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1372832657

Minimum	0
Maximum	0.273963
Zeros	22
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.11293
Q1	0.11634
median	0.143166
Q3	0.146348
95-th percentile	0.166178
Maximum	0.273963
Range	0.273963
Interquartile range (IQR)	0.030008

Descriptive statistics

Standard deviation	0.02462286235
Coefficient of variation (CV)	0.1793580756
Kurtosis	8.36453864
Mean	0.1372832657
Median Absolute Deviation (MAD)	0.019738
Skewness	-0.1195860247
Sum	2005.159379
Variance	0.0006062853503
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.145711	933	6.4%
0.144902	732	5.0%
0.115174	726	5.0%
0.146694	644	4.4%
0.115237	595	4.1%
0.11691	449	3.1%
0.1169	406	2.8%
0.146348	339	2.3%
0.143166	335	2.3%
0.116509	308	2.1%
Other values (506)	9139	62.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22	0.2%
0.0006	66	0.5%
0.000901	6	< 0.1%
0.092453	73	0.5%
0.094486	1	< 0.1%
0.095022	2	< 0.1%
0.095061	1	< 0.1%
0.095558	1	< 0.1%
0.095919	1	< 0.1%
0.096095	1	< 0.1%

Value	Count	Frequency (%)
0.273963	18	0.1%
0.273957	2	< 0.1%
0.272981	21	0.1%
0.272972	1	< 0.1%
0.245926	8	0.1%
0.245347	6	< 0.1%
0.237776	11	0.1%
0.236794	4	< 0.1%
0.236291	3	< 0.1%
0.229272	34	0.2%

forecast_price_energy_peak
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	329
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.05049076722

Minimum	0
Maximum	0.195975
Zeros	7021
Zeros (%)	48.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.084138
Q3	0.098837
95-th percentile	0.10175
Maximum	0.195975
Range	0.195975
Interquartile range (IQR)	0.098837

Descriptive statistics

Standard deviation	0.04903650731
Coefficient of variation (CV)	0.9711975081
Kurtosis	-1.890754679
Mean	0.05049076722
Median Absolute Deviation (MAD)	0.0311955
Skewness	-0.01433142786
Sum	737.468146
Variance	0.002404579049
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7021	48.1%
0.098837	722	4.9%
0.100123	596	4.1%
0.100015	473	3.2%
0.100572	445	3.0%
0.101397	308	2.1%
0.103487	288	2.0%
0.087381	169	1.2%
0.086803	159	1.1%
0.099419	153	1.0%
Other values (319)	4272	29.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7021	48.1%
0.076592	1	< 0.1%
0.077124	1	< 0.1%
0.078125	1	< 0.1%
0.078641	2	< 0.1%
0.078859	1	< 0.1%
0.079221	2	< 0.1%
0.079281	2	< 0.1%
0.079771	1	< 0.1%
0.079799	1	< 0.1%

Value	Count	Frequency (%)
0.195975	1	< 0.1%
0.168092	6	< 0.1%
0.168032	7	< 0.1%
0.146676	8	0.1%
0.136336	59	0.4%
0.13608	1	< 0.1%
0.135761	5	< 0.1%
0.135732	35	0.2%
0.135182	3	< 0.1%
0.134604	2	< 0.1%

forecast_price_pow_off_peak
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	41
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	43.13005553

Minimum	0
Maximum	59.26637796
Zeros	94
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	40.606701
Q1	40.606701
median	44.31137796
Q3	44.31137796
95-th percentile	46.30537836
Maximum	59.26637796
Range	59.26637796
Interquartile range (IQR)	3.70467696

Descriptive statistics

Standard deviation	4.485988222
Coefficient of variation (CV)	0.1040107222
Kurtosis	54.70804128
Mean	43.13005553
Median Absolute Deviation (MAD)	0.9969996
Skewness	-4.998771994
Sum	629957.591
Variance	20.12409033
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
44.31137796	6933	47.5%
40.606701	4651	31.8%
45.80687796	697	4.8%
46.30537836	615	4.2%
45.30837756	419	2.9%
41.1052014	302	2.1%
40.9390266	237	1.6%
41.2713642	160	1.1%
58.99595196	118	0.8%
0	94	0.6%
Other values (31)	380	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	94	0.6%
35.55576792	1	< 0.1%
37.929294	2	< 0.1%
40.606701	4651	31.8%
40.728885	31	0.2%
40.9390266	237	1.6%
41.1052014	302	2.1%
41.1067014	1	< 0.1%
41.2713642	160	1.1%
41.2718682	1	< 0.1%

Value	Count	Frequency (%)
59.26637796	42	0.3%
59.17346796	76	0.5%
59.05128396	1	< 0.1%
58.99595196	118	0.8%
53.28437796	14	0.1%
47.80087836	8	0.1%
47.30687796	2	< 0.1%
47.30237796	10	0.1%
46.80687756	1	< 0.1%
46.80387756	6	< 0.1%

has_gas
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.4 KiB

False	11955
True	2651

Common Values
Chart

Value	Count	Frequency (%)
False	11955	81.8%
True	2651	18.2%

imp_cons
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7752
Distinct (%)	53.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	152.7868958

Minimum	0
Maximum	15042.79
Zeros	6169
Zeros (%)	42.2%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	37.395
Q3	193.98
95-th percentile	638.8175
Maximum	15042.79
Range	15042.79
Interquartile range (IQR)	193.98

Descriptive statistics

Standard deviation	341.3693656
Coefficient of variation (CV)	2.23428432
Kurtosis	380.893698
Mean	152.7868958
Median Absolute Deviation (MAD)	37.395
Skewness	13.19879897
Sum	2231605.4
Variance	116533.0438
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6169	42.2%
0.3	5	< 0.1%
0.1	5	< 0.1%
0.15	4	< 0.1%
34.53	4	< 0.1%
26.26	4	< 0.1%
117.18	4	< 0.1%
26.51	4	< 0.1%
126.6	4	< 0.1%
42.04	4	< 0.1%
Other values (7742)	8399	57.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6169	42.2%
0.06	1	< 0.1%
0.09	2	< 0.1%
0.1	5	< 0.1%
0.14	1	< 0.1%
0.15	4	< 0.1%
0.17	2	< 0.1%
0.24	1	< 0.1%
0.27	1	< 0.1%
0.28	2	< 0.1%

Value	Count	Frequency (%)
15042.79	1	< 0.1%
9682.89	1	< 0.1%
8732.6	1	< 0.1%
8254.16	1	< 0.1%
6787.12	1	< 0.1%
5836.49	1	< 0.1%
5343.76	1	< 0.1%
5311.97	1	< 0.1%
5019.25	1	< 0.1%
4925.36	1	< 0.1%

margin_gross_pow_ele
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	2391
Distinct (%)	16.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.56512118

Minimum	0
Maximum	374.64
Zeros	157
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	3.56
Q1	14.28
median	21.64
Q3	29.88
95-th percentile	51.72
Maximum	374.64
Range	374.64
Interquartile range (IQR)	15.6

Descriptive statistics

Standard deviation	20.23117183
Coefficient of variation (CV)	0.823573052
Kurtosis	35.89260721
Mean	24.56512118
Median Absolute Deviation (MAD)	8.12
Skewness	4.472632135
Sum	358798.16
Variance	409.3003134
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26.04	258	1.8%
33.12	238	1.6%
29.76	170	1.2%
34.68	161	1.1%
0	157	1.1%
23.76	156	1.1%
16.92	156	1.1%
10.08	151	1.0%
19.2	141	1.0%
14.64	135	0.9%
Other values (2381)	12883	88.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	157	1.1%
0.03	1	< 0.1%
0.12	125	0.9%
0.24	16	0.1%
0.36	7	< 0.1%
0.48	1	< 0.1%
0.6	1	< 0.1%
0.64	7	< 0.1%
0.66	1	< 0.1%
0.68	3	< 0.1%

Value	Count	Frequency (%)
374.64	1	< 0.1%
314.76	1	< 0.1%
299.64	1	< 0.1%
248.64	1	< 0.1%
225.12	2	< 0.1%
224.89	1	< 0.1%
224.64	1	< 0.1%
219.88	1	< 0.1%
214.35	1	< 0.1%
214.14	1	< 0.1%

margin_net_pow_ele
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	2391
Distinct (%)	16.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.56251746

Minimum	0
Maximum	374.64
Zeros	157
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	3.56
Q1	14.28
median	21.64
Q3	29.88
95-th percentile	51.72
Maximum	374.64
Range	374.64
Interquartile range (IQR)	15.6

Descriptive statistics

Standard deviation	20.23027977
Coefficient of variation (CV)	0.8236240364
Kurtosis	35.90123205
Mean	24.56251746
Median Absolute Deviation (MAD)	8.12
Skewness	4.473325822
Sum	358760.13
Variance	409.2642197
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26.04	258	1.8%
33.12	238	1.6%
29.76	170	1.2%
34.68	161	1.1%
0	157	1.1%
23.76	156	1.1%
16.92	156	1.1%
10.08	151	1.0%
19.2	141	1.0%
14.64	135	0.9%
Other values (2381)	12883	88.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	157	1.1%
0.03	1	< 0.1%
0.12	125	0.9%
0.24	16	0.1%
0.36	7	< 0.1%
0.48	1	< 0.1%
0.6	1	< 0.1%
0.64	7	< 0.1%
0.66	1	< 0.1%
0.68	3	< 0.1%

Value	Count	Frequency (%)
374.64	1	< 0.1%
314.76	1	< 0.1%
299.64	1	< 0.1%
248.64	1	< 0.1%
225.12	2	< 0.1%
224.89	1	< 0.1%
224.64	1	< 0.1%
219.88	1	< 0.1%
214.35	1	< 0.1%
214.14	1	< 0.1%

nb_prod_act
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.292345611

Minimum	1
Maximum	32
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	32
Range	31
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7097735191
Coefficient of variation (CV)	0.5492133937
Kurtosis	258.9572461
Mean	1.292345611
Median Absolute Deviation (MAD)	0
Skewness	8.636877937
Sum	18876
Variance	0.5037784484
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	11431	78.3%
2	2445	16.7%
3	523	3.6%
4	150	1.0%
5	31	0.2%
9	11	0.1%
6	8	0.1%
8	4	< 0.1%
10	2	< 0.1%
32	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11431	78.3%
2	2445	16.7%
3	523	3.6%
4	150	1.0%
5	31	0.2%
6	8	0.1%
8	4	< 0.1%
9	11	0.1%
10	2	< 0.1%
32	1	< 0.1%

Value	Count	Frequency (%)
32	1	< 0.1%
10	2	< 0.1%
9	11	0.1%
8	4	< 0.1%
6	8	0.1%
5	31	0.2%
4	150	1.0%
3	523	3.6%
2	2445	16.7%
1	11431	78.3%

net_margin
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	11965
Distinct (%)	81.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	189.2645221

Minimum	0
Maximum	24570.65
Zeros	185
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	11.16
Q1	50.7125
median	112.53
Q3	243.0975
95-th percentile	587.685
Maximum	24570.65
Range	24570.65
Interquartile range (IQR)	192.385

Descriptive statistics

Standard deviation	311.7981301
Coefficient of variation (CV)	1.647419847
Kurtosis	2642.965291
Mean	189.2645221
Median Absolute Deviation (MAD)	75.32
Skewness	36.56951466
Sum	2764397.61
Variance	97218.07391
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	185	1.3%
0.49	6	< 0.1%
57.37	5	< 0.1%
0.01	5	< 0.1%
56.33	5	< 0.1%
35.98	5	< 0.1%
86.52	5	< 0.1%
21.48	4	< 0.1%
55.38	4	< 0.1%
91.86	4	< 0.1%
Other values (11955)	14378	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	185	1.3%
0.01	5	< 0.1%
0.02	4	< 0.1%
0.03	3	< 0.1%
0.04	3	< 0.1%
0.05	3	< 0.1%
0.06	1	< 0.1%
0.07	1	< 0.1%
0.08	1	< 0.1%
0.09	2	< 0.1%

Value	Count	Frequency (%)
24570.65	1	< 0.1%
10203.5	1	< 0.1%
4346.37	1	< 0.1%
4305.79	1	< 0.1%
3768.16	1	< 0.1%
3407.65	1	< 0.1%
3403.27	1	< 0.1%
3323.02	1	< 0.1%
3215.03	1	< 0.1%
2711.19	1	< 0.1%

num_years_antig
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.99780912

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	4
median	5
Q3	6
95-th percentile	7
Maximum	13
Range	12
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.611749267
Coefficient of variation (CV)	0.3224911613
Kurtosis	4.07814946
Mean	4.99780912
Median Absolute Deviation (MAD)	1
Skewness	1.446213823
Sum	72998
Variance	2.5977357
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
6	4769	32.7%
4	3982	27.3%
3	2433	16.7%
5	2317	15.9%
7	509	3.5%
11	185	1.3%
12	110	0.8%
8	103	0.7%
9	92	0.6%
10	81	0.6%
Other values (3)	25	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	11	0.1%
3	2433	16.7%
4	3982	27.3%
5	2317	15.9%
6	4769	32.7%
7	509	3.5%
8	103	0.7%
9	92	0.6%
10	81	0.6%

Value	Count	Frequency (%)
13	13	0.1%
12	110	0.8%
11	185	1.3%
10	81	0.6%
9	92	0.6%
8	103	0.7%
7	509	3.5%
6	4769	32.7%
5	2317	15.9%
4	3982	27.3%

origin_up
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	114.2 KiB

lxidpiddsbxsbosboudacockeimpuepw	7097
kamkkxfxxuwbdslkwifmmcsiusiuosws	4294
ldkssxwpmemidmecebumciepifcamkci	3148
MISSING	64
usapbepcfoloekilkwsdiboslwaxobdp	2

Length

Max length	32
Median length	32
Mean length	31.89045598
Min length	7

Characters and Unicode

Total characters	465792
Distinct characters	21
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	lxidpiddsbxsbosboudacockeimpuepw
2nd row	kamkkxfxxuwbdslkwifmmcsiusiuosws
3rd row	kamkkxfxxuwbdslkwifmmcsiusiuosws
4th row	kamkkxfxxuwbdslkwifmmcsiusiuosws
5th row	kamkkxfxxuwbdslkwifmmcsiusiuosws

Common Values

Value	Count	Frequency (%)
lxidpiddsbxsbosboudacockeimpuepw	7097	48.6%
kamkkxfxxuwbdslkwifmmcsiusiuosws	4294	29.4%
ldkssxwpmemidmecebumciepifcamkci	3148	21.6%
MISSING	64	0.4%
usapbepcfoloekilkwsdiboslwaxobdp	2	< 0.1%
ewxeelcelemmiwuafmddpobolfuxioce	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
lxidpiddsbxsbosboudacockeimpuepw	7097	48.6%
kamkkxfxxuwbdslkwifmmcsiusiuosws	4294	29.4%
ldkssxwpmemidmecebumciepifcamkci	3148	21.6%
missing	64	0.4%
usapbepcfoloekilkwsdiboslwaxobdp	2	< 0.1%
ewxeelcelemmiwuafmddpobolfuxioce	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
s	49063	10.5%
i	46771	10.0%
d	38984	8.4%
m	35722	7.7%
c	31084	6.7%
k	30573	6.6%
x	30228	6.5%
u	30228	6.5%
b	28740	6.2%
p	27594	5.9%
Other values (11)	116805	25.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	465344	99.9%
Uppercase Letter	448	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	49063	10.5%
i	46771	10.1%
d	38984	8.4%
m	35722	7.7%
c	31084	6.7%
k	30573	6.6%
x	30228	6.5%
u	30228	6.5%
b	28740	6.2%
p	27594	5.9%
Other values (6)	116357	25.0%

Uppercase Letter

Value	Count	Frequency (%)
I	128	28.6%
S	128	28.6%
N	64	14.3%
M	64	14.3%
G	64	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	465792	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	49063	10.5%
i	46771	10.0%
d	38984	8.4%
m	35722	7.7%
c	31084	6.7%
k	30573	6.6%
x	30228	6.5%
u	30228	6.5%
b	28740	6.2%
p	27594	5.9%
Other values (11)	116805	25.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	465792	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	49063	10.5%
i	46771	10.0%
d	38984	8.4%
m	35722	7.7%
c	31084	6.7%
k	30573	6.6%
x	30228	6.5%
u	30228	6.5%
b	28740	6.2%
p	27594	5.9%
Other values (11)	116805	25.1%

pow_max
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	698
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.13513563

Minimum	3.3
Maximum	320
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	3.3
5-th percentile	10.39
Q1	12.5
median	13.856
Q3	19.1725
95-th percentile	41.5
Maximum	320
Range	316.7
Interquartile range (IQR)	6.6725

Descriptive statistics

Standard deviation	13.53474337
Coefficient of variation (CV)	0.7463271105
Kurtosis	59.20256296
Mean	18.13513563
Median Absolute Deviation (MAD)	3.056
Skewness	5.786784914
Sum	264881.791
Variance	183.1892782
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.2	2124	14.5%
10.392	2000	13.7%
13.856	1504	10.3%
15	583	4.0%
10.35	480	3.3%
19.8	416	2.8%
16.5	405	2.8%
20	294	2.0%
12.5	269	1.8%
13.15	234	1.6%
Other values (688)	6297	43.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.3	3	< 0.1%
3.464	1	< 0.1%
4	1	< 0.1%
5	2	< 0.1%
5.196	2	< 0.1%
5.75	2	< 0.1%
6	2	< 0.1%
6.9	1	< 0.1%
6.928	4	< 0.1%
7.7	1	< 0.1%

Value	Count	Frequency (%)
320	1	< 0.1%
260	1	< 0.1%
200	4	< 0.1%
192	1	< 0.1%
180	2	< 0.1%
166	1	< 0.1%
164	1	< 0.1%
160	2	< 0.1%
155.88	1	< 0.1%
155	3	< 0.1%

churn
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	114.2 KiB

0	13187
1	1419

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	14606
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	13187	90.3%
1	1419	9.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	13187	90.3%
1	1419	9.7%

Most occurring characters

Value	Count	Frequency (%)
0	13187	90.3%
1	1419	9.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	14606	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	13187	90.3%
1	1419	9.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	14606	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	13187	90.3%
1	1419	9.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14606	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	13187	90.3%
1	1419	9.7%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	id	channel_sales	cons_12m	cons_gas_12m	cons_last_month	date_activ	date_end	date_modif_prod	date_renewal	forecast_cons_12m	forecast_cons_year	forecast_meter_rent_12m	forecast_price_energy_off_peak	forecast_price_energy_peak	forecast_price_pow_off_peak	has_gas	imp_cons	margin_gross_pow_ele	margin_net_pow_ele	nb_prod_act	net_margin	num_years_antig	origin_up	pow_max	churn
0	24011ae4ebbe3035111d65fa7c15bc57	foosdfpfkusacimwkcsosbicdxkicaua	0	54946	0	2013-06-15	2016-06-15	2015-11-01	2015-06-23	0.00	0	1.78	0.114481	0.098142	40.606701	t	0.00	25.44	25.44	2	678.99	3	lxidpiddsbxsbosboudacockeimpuepw	43.648	1
1	d29c2c54acc38ff3c0614d0a653813dd	MISSING	4660	0	0	2009-08-21	2016-08-30	2009-08-21	2015-08-31	189.95	0	16.27	0.145711	0.000000	44.311378	f	0.00	16.38	16.38	1	18.89	6	kamkkxfxxuwbdslkwifmmcsiusiuosws	13.800	0
2	764c75f661154dac3a6c254cd082ea7d	foosdfpfkusacimwkcsosbicdxkicaua	544	0	0	2010-04-16	2016-04-16	2010-04-16	2015-04-17	47.96	0	38.72	0.165794	0.087899	44.311378	f	0.00	28.60	28.60	1	6.60	6	kamkkxfxxuwbdslkwifmmcsiusiuosws	13.856	0
3	bba03439a292a1e166f80264c16191cb	lmkebamcaaclubfxadlmueccxoimlema	1584	0	0	2010-03-30	2016-03-30	2010-03-30	2015-03-31	240.04	0	19.83	0.146694	0.000000	44.311378	f	0.00	30.22	30.22	1	25.46	6	kamkkxfxxuwbdslkwifmmcsiusiuosws	13.200	0
4	149d57cf92fc41cf94415803a877cb4b	MISSING	4425	0	526	2010-01-13	2016-03-07	2010-01-13	2015-03-09	445.75	526	131.73	0.116900	0.100015	40.606701	f	52.32	44.91	44.91	1	47.98	6	kamkkxfxxuwbdslkwifmmcsiusiuosws	19.800	0
5	1aa498825382410b098937d65c4ec26d	usilxuppasemubllopkaafesmlibmsdf	8302	0	1998	2011-12-09	2016-12-09	2015-11-01	2015-12-10	796.94	1998	30.12	0.164775	0.086131	45.308378	f	181.21	33.12	33.12	1	118.89	4	lxidpiddsbxsbosboudacockeimpuepw	13.200	1
6	7ab4bf4878d8f7661dfc20e9b8e18011	foosdfpfkusacimwkcsosbicdxkicaua	45097	0	0	2011-12-02	2016-12-02	2011-12-02	2015-12-03	8069.28	0	0.00	0.166178	0.087538	44.311378	f	0.00	4.04	4.04	1	346.63	4	lxidpiddsbxsbosboudacockeimpuepw	15.000	1
7	01495c955be7ec5e7f3203406785aae0	foosdfpfkusacimwkcsosbicdxkicaua	29552	0	1260	2010-04-21	2016-04-21	2010-04-21	2015-04-22	864.73	751	144.49	0.115174	0.098837	40.606701	f	70.63	53.92	53.92	1	100.09	6	lxidpiddsbxsbosboudacockeimpuepw	26.400	0
8	f53a254b1115634330c12c7fdbf7958a	usilxuppasemubllopkaafesmlibmsdf	2962	0	0	2011-09-23	2016-09-23	2011-09-23	2015-09-25	444.38	0	15.85	0.145711	0.000000	44.311378	f	0.00	12.82	12.82	1	42.59	4	kamkkxfxxuwbdslkwifmmcsiusiuosws	13.200	0
9	10c1b2f97a2d2a6f10299dc213d1a370	lmkebamcaaclubfxadlmueccxoimlema	26064	0	2188	2010-05-04	2016-05-04	2015-04-29	2015-05-05	2738.10	2188	130.43	0.115761	0.099419	40.606701	f	219.59	33.42	33.42	1	329.60	6	lxidpiddsbxsbosboudacockeimpuepw	31.500	0

Last rows

	id	channel_sales	cons_12m	cons_gas_12m	cons_last_month	date_activ	date_end	date_modif_prod	date_renewal	forecast_cons_12m	forecast_cons_year	forecast_meter_rent_12m	forecast_price_energy_off_peak	forecast_price_energy_peak	forecast_price_pow_off_peak	has_gas	imp_cons	margin_gross_pow_ele	margin_net_pow_ele	nb_prod_act	net_margin	num_years_antig	origin_up	pow_max	churn
14596	c3f4f737d598a1b47a94440bb18c3c06	lmkebamcaaclubfxadlmueccxoimlema	1097	0	0	2011-02-09	2016-02-09	2011-02-09	2015-02-11	165.60	0	16.04	0.146694	0.000000	44.311378	f	0.00	26.04	26.04	1	17.38	5	ldkssxwpmemidmecebumciepifcamkci	10.392	0
14597	ae818f3cc00ef5845416699aacc4bd7e	ewpakwlliwisiwduibdlfmalxowmwpci	8310	0	685	2012-12-18	2016-12-18	2012-12-18	2015-12-21	833.05	685	131.76	0.115237	0.100123	40.939027	f	67.03	24.02	24.02	1	102.52	3	kamkkxfxxuwbdslkwifmmcsiusiuosws	23.100	0
14598	1582ef35fbfa265e60bb3399bdebac87	MISSING	9441	0	480	2009-10-08	2016-10-08	2015-05-24	2015-10-09	983.97	480	132.11	0.115237	0.100123	40.939027	f	46.98	20.00	20.00	1	113.17	6	ldkssxwpmemidmecebumciepifcamkci	15.001	0
14599	46362cb1ad2fcdad347a6fa1bc1e5d4b	foosdfpfkusacimwkcsosbicdxkicaua	18163	3036	0	2010-01-26	2017-01-26	2015-11-17	2016-01-27	2663.82	0	16.35	0.143575	0.000000	44.311378	t	0.00	31.20	31.20	3	254.81	6	kamkkxfxxuwbdslkwifmmcsiusiuosws	13.856	0
14600	c49217f16a06263e5381eaba94a67a8b	foosdfpfkusacimwkcsosbicdxkicaua	87146	0	11367	2013-02-08	2016-02-08	2013-02-08	2015-02-09	712.33	713	145.82	0.120372	0.103487	40.606701	f	71.81	66.00	66.00	1	87.14	3	lxidpiddsbxsbosboudacockeimpuepw	26.400	0
14601	18463073fb097fc0ac5d3e040f356987	foosdfpfkusacimwkcsosbicdxkicaua	32270	47940	0	2012-05-24	2016-05-08	2015-05-08	2014-05-26	4648.01	0	18.57	0.138305	0.000000	44.311378	t	0.00	27.88	27.88	2	381.77	4	lxidpiddsbxsbosboudacockeimpuepw	15.000	0
14602	d0a6f71671571ed83b2645d23af6de00	foosdfpfkusacimwkcsosbicdxkicaua	7223	0	181	2012-08-27	2016-08-27	2012-08-27	2015-08-28	631.69	181	144.03	0.100167	0.091892	58.995952	f	15.94	0.00	0.00	1	90.34	3	lxidpiddsbxsbosboudacockeimpuepw	6.000	1
14603	10e6828ddd62cbcf687cb74928c4c2d2	foosdfpfkusacimwkcsosbicdxkicaua	1844	0	179	2012-02-08	2016-02-07	2012-02-08	2015-02-09	190.39	179	129.60	0.116900	0.100015	40.606701	f	18.05	39.84	39.84	1	20.38	4	lxidpiddsbxsbosboudacockeimpuepw	15.935	1
14604	1cf20fd6206d7678d5bcafd28c53b4db	foosdfpfkusacimwkcsosbicdxkicaua	131	0	0	2012-08-30	2016-08-30	2012-08-30	2015-08-31	19.34	0	7.18	0.145711	0.000000	44.311378	f	0.00	13.08	13.08	1	0.96	3	lxidpiddsbxsbosboudacockeimpuepw	11.000	0
14605	563dde550fd624d7352f3de77c0cdfcd	MISSING	8730	0	0	2009-12-18	2016-12-17	2009-12-18	2015-12-21	762.41	0	1.07	0.167086	0.088454	45.311378	f	0.00	11.84	11.84	1	96.34	6	ldkssxwpmemidmecebumciepifcamkci	10.392	0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks